package com.zork.cmdb.webapi.mapper.cmdb;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @author chenjh
 * @date 2018/5/16
 * @description
 */
@Mapper
public interface ModuleInstanceMapper {

    @Select("${sql}")
    List<Map<String, Object>> listInstance(@Param("sql") String sql);

    @Select("SELECT [Value] as [value] FROM  [ModuleAttributesOption] where [AttributesID] = #{attributeID}")
    Map<String, Object> getRefModuleID(@Param("attributeID") Integer attributeID);
}
